﻿CREATE VIEW [dbo].[ASMS_V_MaintenanceBillPayItem]
	AS 
SELECT MBPI.*,
	P.[Name] as PayItemName
FROM ASMS_MaintenanceBillPayItem as MBPI
	left join ASMS_PayItem as P on P.Id = MBPI.PayItemId
